﻿CREATE PROCEDURE [dbo].[proc_MgBanDesign_GetList]
(
	@StartIndex int,
	@EndIndex int
)
as	
	Begin
		
		;WITH list As(Select ROW_NUMBER() OVER (Order By Id DESC)AS Row,
			Id,
			CustomerName,
			PicUrl,
			UserName,
			(Select e.EName From Employee e Where e.UserName =UserName) as EName,
			Audit,
			CreateDate
		From MgBanDesign
		)
		Select * From list Where Row between @StartIndex and @EndIndex
	
	End
	RETURN
